-
Re: COUNTIF ... AND ... CONTAINS ...
Hey Jessica - I think you're closer on your second formula. Instead of COUNTIF and AND, just use COUNTIFS: =COUNTIFS({Internal Comms Intake Range 2}, "New Request", {Internal Comms Intake R…5 · -
Re: INDEX and MATCH across two sheets: a detailed explanation
Create some references on the 'new' sheet to the 'original' sheet So, first things first, let's create some References. Go to the "Companies_Public" Sheet. Right click any cell, and press &…6 · -
INDEX and MATCH across two sheets: a detailed explanation
Hello everyone, would love some feedback on this tutorial. I was answering a user's question regarding INDEX and MATCH (thread post here), and thought it would be beneficial to share my example to th…15 ·